CREATE NONCLUSTERED INDEX [IX_index_MasterDeliveryDateCalendar_ychoi_040312] ON [dbo].[MasterDeliveryDateCalendar] 
(
	[Delivery Cycle] ASC
)
INCLUDE ( [Delivery Date]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = ON, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_index_Star_UOMConversionFactors_ychoi_040312] ON [dbo].[Star_UOMConversionFactors] 
(
	[UnitOfMeasure] ASC,
	[ItemNumber] ASC,
	[RelatedUnitOfMeasure] ASC,
	[BusinessUnitCode] ASC,
	[SourceID] ASC
)
INCLUDE ( [ConversionFactor]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]



CREATE NONCLUSTERED INDEX [IX_index_Sales_Star_Facts_ychoi_040312] ON RD_SalesMart.[dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC,
	[CustomerNumberID] ASC,
	[ItemNumber] ASC,
	[UnitOfMeasureAsInput] ASC,
	[SourceID] ASC
)
INCLUDE ( [ExtendedPrice],
[ExtendedCost]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_index_Sales_Star_Facts_2_ychoi_040312] ON RD_SalesMart.[dbo].[Sales_Star_Facts] 
(
	[UnitOfMeasureAsInput] ASC,
	[ItemNumber] ASC,
	[SourceID] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]


CREATE NONCLUSTERED INDEX [IX_index_Sales_Star_Customer_11_ychoi_040312] ON [dbo].[Sales_Star_Customer] 
(
	[ShiptoSearchTypeCode] ASC,
	[LastInvoiceDate] ASC,
	[Category06Code] ASC,
	[ShiptoNumber] ASC,
	[ShiptoName] ASC,
	[Category03Code] ASC
)
WHERE ( [Sales_Star_Customer].[ShiptoSearchTypeCode] <> 'CCX'  AND  [Sales_Star_Customer].[ShiptoSearchTypeCode] <> 'CFX'  AND  [Sales_Star_Customer].[ShiptoSearchTypeCode] <> 'RP '  AND  [Sales_Star_Customer].[ShiptoSearchTypeCode] <> 'RT '  AND  [Sales_Star_Customer].[ShiptoSearchTypeCode] <> 'SP '  AND  [Sales_Star_Customer].[Category06Code] = 'O00' ) 

WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]



CREATE NONCLUSTERED INDEX [IX_index_Sales_Star_Customer_11_2_ychoi_040312] ON [dbo].[Sales_Star_Customer] 
(
	[Category06Code] ASC,
	[ShiptoSearchTypeCode] ASC,
	[CustomerNumberID] ASC,
	[SourceID] ASC,
	[ShiptoNumber] ASC,
	[ShiptoName] ASC,
	[Category03Code] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [IX_index_Sales_Star_Customer_11_3_ychoi_040312] ON [dbo].[Sales_Star_Customer] 
(
	[StopCode] ASC,
	[ShiptoSearchTypeCode] ASC,
	[Category06Code] ASC,
	[SourceID] ASC,
	[ShiptoNumber] ASC,
	[ShiptoName] ASC,
	[Category03Code] ASC
)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
